<?require("config.php");?>


<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Acuity World Training Schedule List</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
td {
	font-family: "Arial", "Helvetica", "sans-serif";
	font-size: 12px;
}
-->
</style>
</head>

<body onload="window.print();">

<table width="600" border="0" cellspacing="0" cellpadding="2">
  <tr> 
    <td width="162" valign="top"><img src="images/logo1.gif" width="162" height="108"></td>
    <td width="325">&nbsp;</td>
    <td width="201"><div align="right"> 
        <table width="100%" border="0" cellpadding="2" cellspacing="0" bgcolor="#000000">
          <tr> 
            <td><table width="100%" border="0" cellspacing="0" cellpadding="2">
                <tr> 
                  <td bgcolor="#FFFFFF"><div align="center"><font size="3" face="Arial, Helvetica, sans-serif"><strong>Training 
                      Schedule</strong></font></div></td>
                </tr>
              </table></td>
          </tr>
        </table>
      </div></td>
  </tr>
</table>
<font size="2" face="Arial, Helvetica, sans-serif"> </font> 
<table width="600" border="0" cellspacing="0" cellpadding="2">
  <tr>
    <td width="24%"><font size="2" face="Arial, Helvetica, sans-serif"><strong>www.acuityworld.com</strong></font></td>
    <td width="51%"><div align="right"><font size="2" face="Arial, Helvetica, sans-serif"></font></div></td>
    <td width="25%"><div align="right"><font color="#0000FF" size="2" face="Arial, Helvetica, sans-serif"></font></div></td>
  </tr>
</table>

<?
$table = "course_schedule";

$field = array(

"id",
"name",
"datedetails",
"time",
"venue",
"country",
"currency",
"fee",
"contact",
"contact_email",
"presented",
"remark",
"contact_tel",
"currency1",
"currency2",
"currency3",
"currency4",
"currency5",
"fee1",
"fee2",
"fee3",
"fee4",
"fee5",
"description1",
"description2",
"description3",
"description4",
"description5",
"order_index",

);

$today=date("Y-m-d");

$exp = "And expiring_date>'$today' order by order_index";

$r = limitQuery($table,$field,$exp);

?>
<?if ($r){?>

<TABLE width="600" border=0 cellPadding=5 cellSpacing=1 bgcolor="#CCCCCC" class=tb>
  <TBODY>
    <TR class=tbheader> 
      <TD width=%><font size="2" face="Arial, Helvetica, sans-serif"><strong>Events/Training</strong></font></TD>
    </TR>


<?

for ($i=0;$i<count($r);$i++){



	$Currency1= $r[$i][13];
	$Currency2= $r[$i][14];
	$Currency3= $r[$i][15];
	$Currency4= $r[$i][16];
	$Currency5= $r[$i][17];
	$Fee1= $r[$i][18];
	$Fee2= $r[$i][19];
	$Fee3= $r[$i][20];
	$Fee4= $r[$i][21];
	$Fee5= $r[$i][22];
	$Description1= $r[$i][23];
	$Description2= $r[$i][24];
	$Description3= $r[$i][25];
	$Description4= $r[$i][26];
	$Description5= $r[$i][27];
	$Order_index= $r[$i][28];
?>

    <TR class=tbcontent1> 

      <TD height="103" vAlign=top bgcolor="#FFFFFF"><p><font size="3" face="Arial, Helvetica, sans-serif"><?=$r[$i][1]?></font><font size="2" face="Arial, Helvetica, sans-serif"><br>
          <br>

		  <table>
		  <tr>
          <td><em><font size="1"><strong>(Date)</strong></font></em></td><td> <?=$r[$i][2]?></td></tr>
          <tr><td><em><strong><font size="1">(Country)</font></strong></em></td><td><?=$r[$i][5]?></td></tr>
          <tr><td><em><strong><font size="1">(Presented in)</font></strong></em></td><td><?=$r[$i][10]?></td></tr>
          <tr><td valign=top><em><strong><font size="1">(Fee)</font></strong></em></td><td> <?for ($q=1;$q<6;$q++){
	
$v1 = "Currency$q";
$v2 = "Fee$q";
$v3 = "Description$q";

if ($$v2>0){
?>
&nbsp;<?=$$v1?> <?=$$v2?> <i><?=$$v3?></i> <BR>
<?}}?></td></tr>
          <tr><td><em><font size="1"><strong>(Remarks)</strong></font></em></td><td><font size="2" face="Arial, Helvetica, sans-serif"> <?=$r[$i][11]?></td></tr>
          <tr><td><em><strong><font size="1">(Contact)</font></strong></em></td><td><?=$r[$i][8]?></td></tr>
          <tr><td><em><strong><font size="1">(Tel)</font></strong></em></td><td><?=$r[$i][12]?></td></tr>
          <tr><td><em><strong><font size="1">(Email)</font></strong></em></td><td><?=$r[$i][9]?></td></tr>
		  </table>



</font></p>
        </TD>
    </TR>


<?
}
?>


  </TBODY>
</TABLE>
<?}?>



<br>
<br>
<br>
      <table width="95%" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td valign="top"><strong>HK representative:<br>
            </strong>Room 20, 11/F, Cammer Commercial Building, 30 Cameron Road,
            Tsimshatsui, Hong Kong <br> 
            <table width="100%" border="0" cellpadding="1" cellspacing="0">
              <tr> 
                <td width="15%">Tel:</td>
                <td width="85%">(852) 2562 8328</td>
              </tr>
              <tr> 
                <td>Fax:</td>
                <td>(852) 2302 9821</td>
              </tr>
              <tr> 
                <td>Email:</td>
                <td><a href="mailto:info@acuityworld.com">info@acuityworld.com</a></td>
              </tr>
            </table>
            <strong><br>
            <br>
            Danmark representative:<br>
            </strong>Dalsoe Park 67, DK 3500, Vaerloese, Danmark<br> <table width="100%" border="0" cellpadding="1" cellspacing="0">
              <tr> 
                <td width="15%">Tel:</td>
                <td width="85%">(45) 4448 6969</td>
              </tr>
              <tr> 
                <td>Email:</td>
                <td><a href="mailto:hwenoe@acuityworld.com">hwenoe@acuityworld.com</a></td>
              </tr>
            </table></td>
        </tr>
      </table>
</body>
</html>
